inherited fRelRazao: TfRelRazao
  Caption = 'CONTABILIDADE / RELAT'#211'RIO'
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 16
  inherited Panel2: TPanel
    Caption = 'RAZ'#195'O'
  end
  inherited GroupBox1: TGroupBox
    object grp1: TGroupBox
      Left = 16
      Top = 28
      Width = 273
      Height = 54
      Caption = '  Per'#237'odo de Lan'#231'amento '
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 0
      object lbl1: TLabel
        Left = 133
        Top = 21
        Width = 7
        Height = 16
        Caption = 'a'
      end
      object lbl2: TLabel
        Left = 6
        Top = 21
        Width = 16
        Height = 16
        Caption = 'De'
      end
      object DTINI: TDateEdit
        Left = 25
        Top = 21
        Width = 101
        Height = 21
        Ctl3D = False
        NumGlyphs = 2
        ParentCtl3D = False
        TabOrder = 0
      end
      object DTFIM: TDateEdit
        Left = 146
        Top = 21
        Width = 101
        Height = 21
        Ctl3D = False
        NumGlyphs = 2
        ParentCtl3D = False
        TabOrder = 1
      end
    end
    object grp2: TGroupBox
      Left = 16
      Top = 92
      Width = 273
      Height = 54
      Caption = '  Intervalo de Contas '
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 1
      object lbl3: TLabel
        Left = 133
        Top = 21
        Width = 7
        Height = 16
        Caption = 'a'
      end
      object lbl4: TLabel
        Left = 6
        Top = 21
        Width = 16
        Height = 16
        Caption = 'De'
      end
      object medt1: TMaskEdit
        Left = 24
        Top = 21
        Width = 101
        Height = 22
        TabOrder = 0
      end
      object medt2: TMaskEdit
        Left = 146
        Top = 21
        Width = 101
        Height = 22
        TabOrder = 1
      end
    end
  end
  inherited RLReport: TRLReport
    Left = 16
    Top = 228
    Borders.Style = bsCross
    DataSource = DSPesquisa
    object RLBand2: TRLBand
      Left = 38
      Top = 120
      Width = 718
      Height = 32
      BandType = btColumnHeader
      Borders.Sides = sdCustom
      Borders.DrawLeft = False
      Borders.DrawTop = False
      Borders.DrawRight = False
      Borders.DrawBottom = True
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
      object RLLabel1: TRLLabel
        Left = 1
        Top = 0
        Width = 31
        Height = 14
        Caption = 'Conta'
      end
      object RLLabel2: TRLLabel
        Left = 193
        Top = 0
        Width = 98
        Height = 14
        Caption = 'Descri'#231#227'o da Conta'
      end
      object RLLabel3: TRLLabel
        Left = 1
        Top = 15
        Width = 71
        Height = 14
        Caption = 'Contra Partida'
      end
      object RLLabel4: TRLLabel
        Left = 113
        Top = 15
        Width = 46
        Height = 14
        Caption = 'Dt.Lanto.'
      end
      object RLLabel5: TRLLabel
        Left = 193
        Top = 15
        Width = 45
        Height = 14
        Caption = 'Hist'#243'rico'
      end
      object RLLabel6: TRLLabel
        Left = 433
        Top = 15
        Width = 33
        Height = 14
        Caption = 'D'#233'bito'
      end
      object RLLabel7: TRLLabel
        Left = 545
        Top = 15
        Width = 37
        Height = 14
        Caption = 'Cr'#233'dito'
      end
      object RLLabel8: TRLLabel
        Left = 666
        Top = 15
        Width = 30
        Height = 14
        Caption = 'Saldo'
      end
    end
    object RLGroup1: TRLGroup
      Left = 38
      Top = 152
      Width = 718
      Height = 89
      DataFields = 'CCON_COGIGOCONTABIL'
      object RLBand4: TRLBand
        Left = 0
        Top = 0
        Width = 718
        Height = 17
        BandType = btHeader
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -12
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        BeforePrint = RLBand4BeforePrint
        object RLDBText10: TRLDBText
          Left = 1
          Top = -1
          Width = 103
          Height = 16
          AutoSize = False
          DataField = 'CCON_COGIGOCONTABIL'
          DataSource = DSPesquisa
        end
        object RLDBText11: TRLDBText
          Left = 193
          Top = -1
          Width = 117
          Height = 15
          DataField = 'CCON_DESCRICAO'
          DataSource = DSPesquisa
        end
        object rlblSaldoInicial: TRLLabel
          Left = 600
          Top = 0
          Width = 104
          Height = 15
          Alignment = taRightJustify
          AutoSize = False
        end
        object rlblDebCredInicial: TRLLabel
          Left = 704
          Top = 0
          Width = 13
          Height = 15
          AutoSize = False
        end
      end
      object RLBand3: TRLBand
        Left = 0
        Top = 17
        Width = 718
        Height = 16
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        BeforePrint = RLBand3BeforePrint
        object RLDBText3: TRLDBText
          Left = 113
          Top = -1
          Width = 70
          Height = 16
          AutoSize = False
          DataField = 'TRANS_DATA'
          DataSource = DSPesquisa
        end
        object RLDBText4: TRLDBText
          Left = 193
          Top = -1
          Width = 205
          Height = 16
          AutoSize = False
          DataField = 'TRANS_HISTORICO1'
          DataSource = DSPesquisa
        end
        object RLDBText5: TRLDBText
          Left = 423
          Top = -1
          Width = 51
          Height = 14
          Alignment = taRightJustify
          DataField = 'DEB_VAL'
          DataSource = DSPesquisa
        end
        object RLDBText6: TRLDBText
          Left = 501
          Top = -1
          Width = 90
          Height = 16
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'CRE_VAL'
          DataSource = DSPesquisa
        end
        object rlblRlSaldo: TRLLabel
          Left = 600
          Top = 0
          Width = 104
          Height = 16
          Alignment = taRightJustify
          AutoSize = False
        end
        object rlblDebCred: TRLDBText
          Left = 704
          Top = 0
          Width = 13
          Height = 16
          AutoSize = False
          DataField = 'TRANS_DEB_CRE'
          DataSource = DSPesquisa
        end
        object RLDBText2: TRLDBText
          Left = 193
          Top = 14
          Width = 205
          Height = 16
          AutoSize = False
          DataField = 'TRANS_HISTORICO2'
          DataSource = DSPesquisa
        end
      end
      object RLBand5: TRLBand
        Left = 0
        Top = 33
        Width = 718
        Height = 26
        BandType = btSummary
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = False
        Borders.DrawRight = False
        Borders.DrawBottom = False
        Borders.Style = bsCross
        object rlbl2: TRLLabel
          Left = -1
          Top = 5
          Width = 720
          Height = 14
          Caption = 
            '_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ' +
            '_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ' +
            '_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBResult1: TRLDBResult
          Left = 391
          Top = -1
          Width = 83
          Height = 14
          Alignment = taRightJustify
          DataField = 'DEB_VAL'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          Info = riSum
          ParentFont = False
        end
        object RLDBResult2: TRLDBResult
          Left = 508
          Top = 0
          Width = 83
          Height = 14
          Alignment = taRightJustify
          DataField = 'CRE_VAL'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          Info = riSum
          ParentFont = False
        end
        object rlbl1: TRLLabel
          Left = 280
          Top = 0
          Width = 39
          Height = 16
          Caption = 'Totais'
        end
      end
    end
  end
  inherited QPesquisa: TQuery
    Filtered = True
    SQL.Strings = (
      '  SELECT VW_LANCAMENTO_CONTABIL.CCON_CODIGO'
      '        ,CONTA_CONTABIL.CCON_COGIGOCONTABIL'
      '        ,CONTA_CONTABIL.CCON_DESCRICAO'
      '        ,VW_LANCAMENTO_CONTABIL.TRANS_DEB_CRE'
      '        ,CASE'
      '           WHEN VW_LANCAMENTO_CONTABIL.TRANS_DEB_CRE = '#39'D'#39' THEN'
      '             VW_LANCAMENTO_CONTABIL.TRANS_VALOR'
      '           WHEN VW_LANCAMENTO_CONTABIL.TRANS_DEB_CRE = '#39'C'#39' THEN'
      '             NULL'
      '         END DEB_VAL'
      '        ,CASE'
      '           WHEN VW_LANCAMENTO_CONTABIL.TRANS_DEB_CRE = '#39'C'#39' THEN'
      '             VW_LANCAMENTO_CONTABIL.TRANS_VALOR'
      '           WHEN VW_LANCAMENTO_CONTABIL.TRANS_DEB_CRE = '#39'D'#39' THEN'
      '             NULL'
      '         END CRE_VAL'
      '        ,VW_LANCAMENTO_CONTABIL.TRANS_HISTORICO1'
      '        ,VW_LANCAMENTO_CONTABIL.TRANS_HISTORICO2'
      '        ,VW_LANCAMENTO_CONTABIL.TRANS_DATA'
      '        ,CONTA_CONTABIL.CCON_NATUREZA_CONTA'
      '   FROM  VW_LANCAMENTO_CONTABIL'
      '        ,CONTA_CONTABIL'
      
        '   WHERE VW_LANCAMENTO_CONTABIL.CCON_CODIGO = CONTA_CONTABIL.CCO' +
        'N_CODIGO'
      'ORDER BY CONTA_CONTABIL.CCON_DESCRICAO'
      '        ,VW_LANCAMENTO_CONTABIL.TRANS_DATA')
    object QPesquisaCCON_CODIGO: TIntegerField
      FieldName = 'CCON_CODIGO'
    end
    object QPesquisaCCON_COGIGOCONTABIL: TStringField
      FieldName = 'CCON_COGIGOCONTABIL'
      Size = 100
    end
    object QPesquisaCCON_DESCRICAO: TStringField
      FieldName = 'CCON_DESCRICAO'
      Size = 40
    end
    object QPesquisaTRANS_DEB_CRE: TStringField
      FieldName = 'TRANS_DEB_CRE'
      FixedChar = True
      Size = 1
    end
    object QPesquisaDEB_VAL: TFloatField
      FieldName = 'DEB_VAL'
      DisplayFormat = '0,.00'
    end
    object QPesquisaCRE_VAL: TFloatField
      FieldName = 'CRE_VAL'
      DisplayFormat = '0,.00'
    end
    object QPesquisaTRANS_HISTORICO1: TStringField
      FieldName = 'TRANS_HISTORICO1'
      Size = 60
    end
    object QPesquisaTRANS_HISTORICO2: TStringField
      FieldName = 'TRANS_HISTORICO2'
      Size = 60
    end
    object QPesquisaTRANS_DATA: TDateTimeField
      FieldName = 'TRANS_DATA'
      DisplayFormat = 'DD/MM/YYYY'
    end
    object QPesquisaCCON_NATUREZA_CONTA: TStringField
      FieldName = 'CCON_NATUREZA_CONTA'
      FixedChar = True
      Size = 1
    end
  end
end
